<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateSStuApplyInfo extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('s_stu_apply_info', function (Blueprint $table) {
            $table->increments('id');

            $table->string('name')->comment("姓名")->index();
            $table->string('name_en')->comment("英文名");
            $table->string('profession')->comment("职业");
            $table->string('phone')->comment("电话")->index();
            $table->string('wx_num')->comment("微信号")->index();
            $table->string('type')->comment("课程类别");
            $table->string('level')->comment("英语口语水平");
            $table->string('test')->comment("是否参与过测试");
            $table->date('ielts_time')->comment("预备雅思考试时间");
            $table->date('toefl_time')->comment("预备托福考试时间");

            $table->integer('ielts_num')->comment("雅思考试分数");
            $table->integer('toefl_num')->comment("托福考试分数");

            $table->integer('ielts_aim')->comment("目标雅思分数");
            $table->integer('toefl_aim')->comment("目标托福分数");

            $table->string('content', 2000)->comment("内容");
            $table->string('hobby', 2000)->comment("爱好");
            $table->string('except', 2000)->comment("想的老师");
            $table->string('times', 2000)->comment("时间段");
            $table->dateTime('created_at')->comment("提交时间")->index();

        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
